Configuring: Interpolate Empty Values

Select the fields containing null values that you want to fill using interpolated values. You can select as many fields as required.

Worked example: Interpolate empty values

Steps to configure

Field selection : Select all the fields that you want to interpolate.
Execution: The dataset will be modified to contain interpolated values replacing the original null values in these fields.

Step 1: Field selection

Select the fields containing null values that you want to fill using interpolated values. You can select all the fields that are listed or just one field. All the null values will be replaced with interpolated values falling between the last and the next known value.

Only integer, double and timestamp fields will be available for selection.
Only fields containing null values will be listed.
Default: no fields are selected.
Minimum configuration: at least one field must be selected.

Step 2: Execution

The dataset will be modified. All the null values will be replaced with linearly interpolated values falling between the last and the next known value. If the first value is a null value, it will remain null as there is no previous known value to use for interpolation.